Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyFunctionID (FK) | A unique system assigned identifier for the MerchandiseHierarchyFunction | ID_MRHRC_FNC | Identity | integer | MerchandiseHierarchyLevel(CO_MRHRC_LV) |
MerchandiseHierarchyFunctionID (FK)(PK) | A unique system assigned identifier for the MerchandiseHierarchyFunction | ID_MRHRC_FNC | Identity | integer | MerchandiseHierarchyFunction(CO_MRHRC_FNC) |
MerchandiseHierarchyLevelID (PK) | A unique system assigned identifier for the Level within the merchandise hierarchy tree. | ID_MRHRC_LV | Identity | integer | |
ParentMerchandiseHierarchyLevelID (FK) | Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. | ID_MRHRC_LV_PRNT | Identity | integer | MerchandiseHierarchyLevel(CO_MRHRC_LV) |
Name | The retailer-specific description associated with a merchandise-hierarchy-level-code. This attribute allows retailers to assign any description they choose to each level. | DE_MRHRC_LV | Name | varchar(40) | |